<?php

//get all orderdetail	
function getAllOrderDetail(){
	$qr ="SELECT * FROM `orderdetail`";
	return mysql_query($qr);
}

//add orderdetail	
function addOrderDetail($orderID,$productID,$productNumber){
	$qr ="INSERT INTO `orderdetail`(OrderID,ProductID,ProductNumber) VALUES('$orderID','$productID','$productNumber')";
	mysql_query($qr);
}

//get list orderdetail by orderid	
function getListOrderDetailByOrderID($orderID){
	$qr ="SELECT * FROM `orderdetail` WHERE OrderID = $orderID;";
	return mysql_query($qr);
}
?>